package com.hyst.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.hyst.model.UserViewModel;

@Repository
public interface UserView_Repository extends JpaRepository<UserViewModel, String>  {
	@Query(value = "select * from person_view", nativeQuery = true)//where user_name CONCAT('%',?1,'%')
	List<UserViewModel> findByAll();
	
	UserViewModel findOneByUserId(String userid);
}
